Teiid provides an extensive set of built-in scalar functions. See also SQL Support and Datatypes. In addition, Teiid provides the capability for user defined functions or UDFs. See the Developers Guide for adding UDFs. Once added UDFs may be called just like any other function.